FuelPriceLevel

Entity Definition

Logical Name : FuelPriceLevel
Physical Name : CO_LV_PRC

A collection of price levels, which are merely parameters to the ITEM PRICE structure for fuel prices. Examples are "Cash Price", "Credit Price"

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PriceLevelID (PK) A unique identifier for the price level ID_LV_PRC Identity integer
Name A human readable name for the price level NM_LV_PRC Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
FuelPriceLevel uses FuelItemPrice
FuelPriceLevel is summarized to NozzleFuelingTransactionHistory

Logical Views containing FuelPriceLevel

Logical View
Logical 20000 - Forecourt Macro View
Logical 20020 - Forecourt Pricing View